package com.example.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.common.utils.R;
import com.example.system.entity.Order;
import com.example.system.entity.Patient;
import org.apache.ibatis.annotations.Mapper;

import javax.servlet.http.HttpServletResponse;
import java.sql.Time;
import java.time.LocalDate;
import java.time.LocalTime;
import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 王鹤蒲
 * @since 2024-02-03
 */
@Mapper
public interface OrderMapper extends BaseMapper<Order> {

    public Page<Order> findByPage(Page<Order> page, String orderNo, String status, String type, String createBy, LocalDate createDate);
    public Order selectOrderMedicalCertificateDetailInfo(String certificateNo);

    public Page<Order> findOrderDetailListByPage(Page<Order> orderPage,Integer userId,String workDate,String status);

    public Page<Order> findPatientOrderList(Page<Order> orderPage,Integer userId,String orderDate,String status);
    public List<Map<String,Object>> getInvalidAppointmentTimeList(Integer appointmentSchedulerId);

    public List<String> getRegisteredUserEmailList(Integer appointmentSchedulerId);
}
